{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main Lab","Sub Steps","Practice Problem"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Lab","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,0,26,2],[19,0,19,2],[16,0,16,1],[17,0,17,1],[3,5,3,6],[4,5,4,6]]}
["CE EN 114 Lab 5 Grader"]
[]
["Side","Azimuth Angles","Bearing Angles"]
[1,"25* 25' 25 '' ","N 25* 25' 25 '' E",null,null,"Interior Angles Balanced?",null,"No"]
[2,"230* 50' 50 '' ","S 50* 50' 50 '' W",null,null,"Perimeter:",null,48]
[3,"76* 16' 15 '' ","N 76* 16' 15 '' E"]
[4,"281* 41' 40 '' ","N 78* 18' 20 '' W"]
[]
["Side","Latitude (Y)","Departure(X)"]
[1,10.837903397909162,5.1516841845739165]
[2,-7.5767163702231066,-9.3055558160269598]
[3,2.8480053473926246,11.657137965265017]
[4,2.4322593563280774,-11.750919726708821]
[]
["Error:",8.5414517314067577,-4.2476533928968472]
[]
["Vector of Closure:",null,9.5393373473286704]
["Precision:",null,"1 to 5"]
[]
["Adjusted Values"]
["Side","Latitude (Y)","Departure(X)"]
[1,8.9093319657656131,5.6075710346934668]
[2,-6.2284630960810219,-10.129030310500665]
[3,2.3412115931104904,12.68871049921553]
[4,1.9994463169460204,-12.790791269350763]
[]
["Coordinates"]
["Point","Latitude (Y)","Departure(X)"]
["A",4455361.2189999996,444637.2]
["B",4455370.1283319658,444642.8075710347]
["C",4455363.8998688692,444632.67854072421]
["D",4455366.241080462,444645.36725122342]
[null,{"$f":"B29","v":4455361.2189999996},{"$f":"C29","v":444637.2}]
["Area:",5.3569409847259521]

{"sheet":"Sub Steps","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,5,1,6],[11,4,11,6],[0,8,0,9],[16,1,16,2],[16,3,16,4],[9,1,9,2],[24,0,24,1],[9,10,9,11],[11,13,11,15],[16,10,16,11],[16,12,16,13],[24,9,24,10]]}
["Balanced Angles",null,null,null,null,null,null,null,"Key"]
["Angle","Degrees","Minutes","Seconds",null,"Sides of the Traverse",null,null,null,"Answer"]
["Angle A",null,null,null,null,"Side 1"]
["Angle B",null,null,null,null,"Side 2",null,null,null,"Input"]
["Angle C",null,null,null,null,"Side 3"]
["Angle D",null,null,null,null,"Side 4"]
["Sum:",{"$f":"SUM(B3:B6)+SUM(C3:C6)/60+SUM(D3:D6)/3600","v":0},null,null,null,"Perimeter",{"$f":"SUM(G3:G6)","v":0}]
[]
[]
[null,"Counterclockwise",null,null,null,null,null,null,null,null,"Clockwise"]
["Azimuths","Degrees","Minutes","Seconds",null,null,null,null,null,"Azimuths","Degrees","Minutes","Seconds"]
["Side 1",null,null,null,"Adjusted Azimuths",null,null,null,null,"Side 1",null,null,null,"Adjusted Azimuths"]
["Side 2",{"$f":"(B12+180+B4)","v":180},{"$f":"(C12+C4)","v":0},0,{"$f":"IF(B13>=360,B13-360,B13)+IF(C13<120,IF(C13<60,0,1),2)","v":180},{"$f":"IF(C13<120,IF(C13<60,C13,C13-60),C13-120)+IF(D13<120,IF(D13<60,0,1),2)","v":0},{"$f":"IF(D13<120,IF(D13<60,D13,D13-60),D13-120)","v":0},null,null,"Side 2",{"$f":"(K12+180+B4)","v":180},{"$f":"(L12+B4)","v":0},{"$f":"(M12+B4)","v":0},{"$f":"IF(K13>=360,K13-360,K13)+IF(L13<120,IF(L13<60,0,1),2)","v":180},{"$f":"IF(L13<120,IF(L13<60,L13,L13-60),L13-120)+IF(M13<120,IF(M13<60,0,1),2)","v":0},{"$f":"IF(M13<120,IF(M13<60,M13,M13-60),M13-120)","v":0}]
["Side 3",{"$f":"(B13+180+B5)","v":360},0,0,{"$f":"IF(B14>=360,B14-360,B14)+IF(C14<120,IF(C14<60,0,1),2)","v":0},{"$f":"IF(C14<120,IF(C14<60,C14,C14-60),C14-120)+IF(D14<120,IF(D14<60,0,1),2)","v":0},{"$f":"IF(D14<120,IF(D14<60,D14,D14-60),D14-120)","v":0},null,null,"Side 3",{"$f":"(K13+180+B5)","v":360},{"$f":"(L13+B5)","v":0},{"$f":"(M13+B5)","v":0},{"$f":"IF(K14>=360,K14-360,K14)+IF(L14<120,IF(L14<60,0,1),2)","v":0},{"$f":"IF(L14<120,IF(L14<60,L14,L14-60),L14-120)+IF(M14<120,IF(M14<60,0,1),2)","v":0},{"$f":"IF(M14<120,IF(M14<60,M14,M14-60),M14-120)","v":0}]
["Side 4",540,0,0,180,0,0,null,null,"Side 4",540,0,0,180,0,0]
[]
[null,"Original",null,"Adjusted",null,null,null,null,null,null,"Original",null,"Adjusted"]
[null,"Latitude","Departure","Latitude","Departure",null,null,null,null,null,"Latitude","Departure","Latitude","Departure"]
["Side 1",{"$f":"G3*COS(PI()/180*(B12+C12/60+D12/3600))","v":0},{"$f":"G3*SIN(PI()/180*(B12+C12/60+D12/3600))","v":0},null,null,null,null,null,null,"Side 1",{"$f":"P3*COS(PI()/180*(K12+L12/60+M12/3600))","v":0},{"$f":"P3*SIN(PI()/180*(K12+L12/60+M12/3600))","v":0}]
["Side 2",{"$f":"G4*COS(PI()/180*(B13+C13/60+D13/3600))","v":0},{"$f":"G4*SIN(PI()/180*(B13+C13/60+D13/3600))","v":0},null,null,null,null,null,null,"Side 2",{"$f":"P4*COS(PI()/180*(K13+L13/60+M13/3600))","v":0},{"$f":"P4*SIN(PI()/180*(K13+L13/60+M13/3600))","v":0}]
["Side 3",0,0,null,null,null,null,null,null,"Side 3",0,0]
["Side 4",0,0,null,null,null,null,null,null,"Side 4",0,0]
[]
["Error",{"$f":"SUM(B19:B22)","v":0},{"$f":"SUM(C19:C22)","v":0},{"$f":"SUM(D19:D22)","v":0},0,null,null,null,null,"Error",{"$f":"SUM(K19:K22)","v":0},{"$f":"SUM(L19:L22)","v":0},{"$f":"SUM(M19:M22)","v":0},0]
["Vector of Closure",null,{"$f":"SQRT(B24^2+C24^2)","v":0},null,null,null,null,null,null,"Vector of Closure",null,{"$f":"SQRT(K24^2+L24^2)","v":0}]
["Precision","1 to",{"$f":"IF(C25>0,G7/C25,0)","v":0},null,null,null,null,null,null,"Precision","1 to",{"$f":"IF(L25>0,P7/L25,0)","v":0}]
[]
["Coordinates","Y","X",null,null,null,null,null,null,"Coordinates","Y","X"]
["Point A",null,null,null,null,null,null,null,null,"Point A"]
["Point B",null,null,null,null,null,null,null,null,"Point B"]
["Point C",null,null,null,null,null,null,null,null,"Point C"]
["Point D",null,null,null,null,null,null,null,null,"Point D"]
[null,{"$f":"B29","v":0},{"$f":"C29","v":0},null,null,null,null,null,null,null,{"$f":"K29","v":0},{"$f":"L29","v":0}]
["Area",{"$f":"ABS((B29*C30+B30*C31+B31*C32+B32*C33)-(C29*B30+C30*B31+C31*B32+C32*B33))/2","v":0},null,null,null,null,null,null,null,"Area",{"$f":"ABS((K29*L30+K30*L31+K31*L32+K32*L33)-(L29*K30+L30*K31+L31*K32+L32*K33))/2","v":0}]

{"sheet":"Practice Problem","index":2,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,1],[8,0,8,1],[15,0,15,1],[32,0,32,1],[39,0,39,1]]}
["Corrected Angles"]
["E",92,4,42]
["D",116,19,12,null,null,null,null,null,null,null,null,"Coordinates:","Y","X"]
["C",80,58,42,null,null,null,null,null,null,null,null,"A",1000,500]
["B",149,13,12,null,null,null,null,null,null,null,null,"E",{"$f":"N4+K23","v":688.69},{"$f":"O4+L23","v":660.274}]
["A",101,24,12,null,null,null,null,null,null,null,null,"D",{"$f":"N5+K24","v":934.77200000000005},1184.537]
[null,null,null,null,null,null,null,null,null,null,null,null,"C",1302.9650000000001,1192.1310000000001]
[null,"Counterclockwise:",null,null,null,null,null,null,null,null,null,null,"B",1250.7320000000002,{"$f":"O7+L26","v":813.60400000000004}]
["Azimuth Angles",null,null,null,null,"Lengths","Lat (Y)","Dep (X)",null,null,null,null,"A",1000,500]
["AE",152,46,12,null,350.1,-311.30099999999999,160.19300000000001]
["ED",64,50,54,null,579.03,246.09700000000001,524.13,null,null,null,null,"Area",{"$f":"ABS((N4*O5+N5*O6+N6*O7+N7*O8+N8*O9)-(O4*N5+O5*N6+O6*N7+O7*N8+O8*N9))/2","v":266857.14405149966}]
["DC",1,10,6,null,368.28,368.20299999999997,7.5090000000000003]
["CB",262,8,48,null,382.2,-52.222999999999999,-378.61500000000001]
["BA",231,22,0,null,401.58,-250.72,-313.697]
[]
["Bearing Angles",null,null,null,null,"Error:",{"$f":"SUM(G10:G14)","v":5.6000000000011596E-2},{"$f":"SUM(H10:H14)","v":-0.48000000000001819}]
["AE","S 27",13,"48 E"]
["ED","N 64",50,"54 E",null,"Vector of Closure:",null,0.48325560000000001]
["DC","N 1",10,"6 E",null,"Perimeter:",null,{"$f":"SUM(F10:F14)","v":2081.19}]
["CB","S 82",8,"48 W",null,"Precision:",null,"\"1:4308\""]
["BA","S 51",22,"0 W"]
[null,null,null,null,null,"Error:","Lat (Y)","Dep (X)",null,"New:","Lat (Y)","Dep (X)"]
[null,null,null,null,null,"AE",-8.9999999999999993E-3,8.1000000000000003E-2,null,"AE",{"$f":"G10+G23","v":-311.31},{"$f":"H10+H23","v":160.274}]
[null,null,null,null,null,"ED",-1.4999999999999999E-2,0.13300000000000001,null,"ED",{"$f":"G11+G24","v":246.08200000000002},524.26300000000003]
[null,null,null,null,null,"DC",-0.01,8.5000000000000006E-2,null,"DC",368.19299999999998,7.5940000000000003]
[null,null,null,null,null,"CB",-0.01,8.7999999999999995E-2,null,"CB",-52.232999999999997,-378.52699999999999]
[null,null,null,null,null,"BA",-1.2E-2,9.2999999999999999E-2,null,"BA",-250.732,-313.60399999999998]
[null,null,null,null,null,null,{"$f":"SUM(G23:G27)","v":-5.6000000000000008E-2},{"$f":"SUM(H23:H27)","v":0.48},null,null,{"$f":"SUM(K23:K27)","v":0},{"$f":"SUM(L23:L27)","v":0}]
[]
[]
[]
[null,"Clockwise:"]
["Azimuth Angles",null,null,null,null,"Lengths","Lat (Y)","Dep (X)"]
["AB",51,22,0,null,401.58,250.72,313.697]
["BC",82,8,48,null,382.2,52.222999999999999,378.61500000000001]
["CD",181,10,6,null,368.28,-368.20299999999997,-7.5090000000000003]
["DE",244,50,54,null,579.03,-246.09700000000001,-524.13]
["EA",332,46,12,null,350.1,311.30099999999999,-160.19300000000001]
[]
["Bearing Angles",null,null,null,null,"Error:",{"$f":"SUM(G34:G38)","v":-5.5999999999983174E-2},{"$f":"SUM(H34:H38)","v":0.47999999999998977}]
["AB","N 51",22,"0 E"]
["BC","N 82",8,"48 E",null,"Vector of Closure:",null,0.48325560000000001]
["CD","S 1",10,"6 W",null,"Perimeter:",null,{"$f":"SUM(F34:F38)","v":2081.19}]
["DE","S 64",50,"54 W",null,"Precision:",null,"\"1:4308\""]
["EA","N 27",13,"48 W"]
[null,null,null,null,null,"Adjustments:","Lat (Y)","Dep (X)",null,"New:","Lat (Y)","Dep (X)"]
[null,null,null,null,null,"AB",8.9999999999999993E-3,-8.1000000000000003E-2,null,"AB",{"$f":"G34+G47","v":250.72899999999998},{"$f":"H34+H47","v":313.61599999999999}]
[null,null,null,null,null,"BC",1.4999999999999999E-2,-0.13300000000000001,null,"BC",{"$f":"G35+G48","v":52.238},378.48200000000003]
[null,null,null,null,null,"CD",0.01,-8.5000000000000006E-2,null,"CD",-368.19299999999998,-7.5940000000000003]
[null,null,null,null,null,"DE",0.01,-8.7999999999999995E-2,null,"DE",-246.08700000000002,-524.21799999999996]
[null,null,null,null,null,"EA",1.2E-2,-9.2999999999999999E-2,null,"EA",311.31299999999999,-160.286]
[null,null,null,null,null,null,{"$f":"SUM(G47:G51)","v":5.6000000000000008E-2},{"$f":"SUM(H47:H51)","v":-0.48},null,null,{"$f":"SUM(K47:K51)","v":0},{"$f":"SUM(L47:L51)","v":0}]